namespace Module.Core.DAO
{
	public class DbConstants
    {
    
        #region ADVERTISEMENT
        public struct ADVERTISEMENT
        {
            public const string ADVERTISEMENTID = "AdvertisementID";
            public const string TITLE = "Title";
            public const string DESCRIPTION = "Description";
            public const string MEDIASRC = "MediaSrc";
            public const string WIDTH = "Width";
            public const string HEIGHT = "Height";
            public const string MEDIATYPE = "MediaType";
            public const string TARGET = "Target";
            public const string PRIORITY = "Priority";
            public const string CREATEDBY = "CreatedBy";
            public const string CREATEDON = "CreatedOn";
            public const string STARTDATE = "StartDate";
            public const string ENDDATE = "EndDate";
            public const string CUSTOMERID = "CustomerID";
            public const string CLICK = "Click";
            public const string VIEWCOUNT = "ViewCount";
            public const string ISENABLE = "IsEnable";
            public const string POSITIONID = "PositionID";
        }
        #endregion

        #region ADVERTISEMENT_POSITIONS
        public struct ADVERTISEMENT_POSITIONS
        {
            public const string POSITIONID = "PositionID";
            public const string TITLE = "Title";
            public const string DESCRIPTION = "Description";
            public const string SHOWMODE = "ShowMode";
            public const string REPEATLAYOUT = "RepeatLayout";
            public const string REPEATCOLUMNS = "RepeatColumns";
            public const string REPEATDIRECTION = "RepeatDirection";
            public const string CREATEDBY = "CreatedBy";
            public const string CREATEDON = "CreatedOn";
            public const string WIDTH = "Width";
            public const string HEIGHT = "Height";
            public const string TIMEDELAY = "TimeDelay";
            public const string PRIORITY = "Priority";
            public const string LANG = "Lang";
            public const string GroupPostion = "GroupPostion";

        }
        #endregion

        #region CHUYENGOLD
        public struct CHUYENGOLD
        {
            public const string ID = "Id";
            public const string CODEMEMBER_TO = "CodeMember_To";
            public const string CODEMEMBER_FROM = "CodeMember_From";
            public const string IP = "IP";
            public const string CREATEDATE = "CreateDate";
            public const string GOLD = "Gold";
            public const string DESCRIPTION = "Description";
            public const string NUMBERACOUNT = "NumberAcount";
            public const string NAMEBANK = "NameBank";
            public const string CODEACTIVE = "CodeActive";
            public const string ISACTIVE = "IsActive";
            public const string STATUS = "Status";
            public const string FULLNAME_TO = "FullName_To";
            public const string NAMEACOUNT = "NameAcount";
            public const string TYPE = "Type";


        }
        #endregion

        #region CMS_ZONES
        public struct CMS_ZONES
        {
            public const string ZONEID = "ZoneID";
            public const string ZONEIDLANG = "ZoneIDLang";
            public const string PARENTID = "ParentID";
            public const string TITLE = "Title";
            public const string PRIORITY = "Priority";
            public const string LANG = "Lang";
            public const string CREATEDON = "CreatedOn";
            public const string CREATEDBY = "CreatedBy";
            public const string DELETEDON = "DeletedOn";
            public const string DELETEDBY = "DeletedBy";
            public const string KEYZONE = "KeyZone";
            public const string ZONEURL = "ZoneUrl";
            public const string MODULEMENU = "ModuleMenu";
            public const string IMAGESZONE = "ImagesZone";
            public const string STATUSCLICK = "StatusClick";
            public const string CHECKZONE = "CheckZone";
            public const string TRANGHIENTHI = "TrangHienThi";
        }
        #endregion

        #region COUNTRYCITY
        public struct COUNTRYCITY
        {
            public const string COUNTRY_ID = "Country_ID";
            public const string COUNTRY_PARENT = "Country_Parent";
            public const string COUNTRY_TITLE = "Country_Title";
            public const string COUNTRY_DESCRIPTION = "Country_Description";
            public const string LANG = "Lang";
            public const string PRIORITY = "Priority";
            public const string CREATEDBY = "CreatedBy";
            public const string CREATEDON = "CreatedOn";
            public const string COUNTRY_IDLANG = "Country_IDLang";
            public const string COUNTRY_LEVEL = "Country_Level";
        }
        #endregion

        #region CMS_CONFIG
        public struct CMS_CONFIG
        {
            public const string CONFIGID = "ConfigId";
            public const string CONFIGIDLANG = "ConfigIdLang";
            public const string CONFIGVALUE_VN = "ConfigValue_VN";
            public const string STATUS = "Status";
            public const string LANG = "Lang";
            public const string CONFIGVALUE_ENG = "ConfigValue_Eng";
            public const string CONFIGKEY = "ConfigKey";
        }
        #endregion

        #region CMS_CONTENTS
        public struct CMS_CONTENTS
        {
            public const string CONTENTID = "ContentID";
            public const string CONTENTLANGID = "ContentLangID";
            public const string CONTENTVERSIONID = "ContentVersionID";
            public const string VERSIONID = "VersionID";
            public const string ZONEID = "ZoneID";
            public const string HEADLINE = "Headline";
            public const string SUBHEADLINE = "SubHeadline";
            public const string TEASER = "Teaser";
            public const string AVATAR = "Avatar";
            public const string AVATARTEASER = "AvatarTeaser";
            public const string SMALLAVATAR = "SmallAvatar";
            public const string BIGAVATAR = "BigAvatar";
            public const string ATTACHFILE = "AttachFile";
            public const string STATUS = "Status";
            public const string BODY = "Body";
            public const string PRIMARYAUTHOR = "PrimaryAuthor";
            public const string SECONDARYAUTHORS = "SecondaryAuthors";
            public const string CREATEDBY = "CreatedBy";
            public const string CREATEDON = "CreatedOn";
            public const string MODIFIEDBY = "ModifiedBy";
            public const string MODIFIEDON = "ModifiedOn";
            public const string DELETEDON = "DeletedOn";
            public const string DELETEDBY = "DeletedBy";
            public const string DATETIMEPUBLISH = "DatetimePublish";
            public const string USERPUBLISH = "UserPublish";
            public const string DATETIMEREMOVE = "DatetimeRemove";
            public const string USERREMOVE = "UserRemove";
            public const string SHOWTYPE = "ShowType";
            public const string LANG = "Lang";
            public const string HITCOUNT = "HitCount";
            public const string URL = "URL";
            public const string KEYCONTENTS = "KeyContents";
            public const string RETURNBODY = "ReturnBody";
            public const string LOCKED = "Locked";
            public const string HITCOUNTCOMMENTS = "HitCountComments";
            public const string AUTHOR = "Author";
            public const string CHECK_TYPE = "Check_type";
        }
        #endregion
                
        #region MUSICMANAGER
        public struct MUSICMANAGER
        {
            public const string MUSICMANAGEID = "MusicManageId";
            public const string MUCSICNAME = "MucsicName";
            public const string KEYWORD = "Keyword";
            public const string PRICE = "Price";
            public const string DESCIPTION = "Desciption";
            public const string IMAGES = "Images";
            public const string ZONEID = "ZoneId";
            public const string MUSICIANID = "MusicianId";
            public const string SINGERID = "SingerId";
            public const string PAGEVIEWS = "PageViews";
            public const string NUMBERDOWNLOAD = "NumberDownload";
            public const string STATUS = "Status";
            public const string TYPE = "Type";
            public const string CREATEDBY = "CreatedBy";
            public const string CREATEDON = "CreatedOn";
            public const string GROUPMUSICID = "GroupMusicId";
            public const string LANG = "Lang";
            public const string FILEMUSIC = "FileMusic";
            public const string SHORTCODE = "ShortCode";
            public const string CODEID = "CodeId";
            public const string SINGERNAME = "SingerName";
            
        }
        #endregion

        #region ONLINESUPPORTS
        public struct ONLINESUPPORTS
        {
            public const string ONLINESUPPORTID = "OnlineSuport_Id";
            public const string TITLE = "Title";
            public const string EMAIL = "Email";
            public const string DESCRIPTION = "Description";
            public const string YAHOO = "Yahoo";
            public const string SKY = "Sky";
            public const string SUPPORTTYPE = "SupportType";
            public const string NICKNAME = "NickName";
            public const string PHONE = "Phone";
            public const string MOBILE = "Mobile";
            public const string PRIORITY = "Priority";
            public const string STATUS = "Status";
        }
        #endregion

        #region SINGER
        public struct SINGER
        {
            public const string SINGERID = "SingerId";
            public const string SINGERNAME = "SingerName";
            public const string MOBILE = "Mobile";
            public const string DESCRIPTION = "Description";
            public const string CREATEDBY = "CreatedBy";
            public const string CREATEDON = "CreatedOn";
            public const string ADDRESS = "Address";
            public const string BIRTHDAY = "BirthDay";
            public const string TYPE = "Type";
            public const string IMAGES = "Images";
            public const string KEYWORD = "Keyword";
            public const string Status = "Status";
        }
        #endregion               

        #region CMS_USERROLEZONE
        public struct CMS_USERROLEZONE
        {
            public const string USERROLEZONEID = "UserRoleZoneID";
            public const string LANG = "Lang";
            public const string ROLEID = "RoleID";
            public const string CHECKROLE = "CheckRole";
            public const string ZONEIDLANG = "ZoneIDLang";
        }
        #endregion

                       
        #region CONFIGKEYWORD
        public struct CONFIGKEYWORD
        {
            public const string CONFIGID = "ConfigId";
            public const string CONFIGIDLANG = "ConfigIdLang";
            public const string CONFIGVALUE_VN = "ConfigValue_VN";
            public const string STATUS = "Status";
            public const string LANG = "Lang";
            public const string CONFIGVALUE_ENG = "ConfigValue_Eng";
            public const string CONFIGKEY = "ConfigKey";
        }
        #endregion
                
        #region NewLetter_Emails
        public struct NewLetterEmails
        {
            public const string EMAILID = "EmailId";
            public const string GROUPID = "GroupId";
            public const string DATE = "Date";
            public const string EMAIL = "Email";
            public const string FULLNAME = "FullName";
            public const string ADDRESS = "Address";
            public const string ENABLE = "Enable";
            public const string CREATEDBY = "CreatedBy";
  
        }
        #endregion

         #region  PRODUCTS
        public struct PRODUCTS
        {
            public const string PRODUCTID = "ProductId";
            public const string PRODUCTIDNAME = "ProductName";
            public const string ZONEID = "ZoneId";
            public const string CITYID = "CityId";
            public const string PRICE = "Price";
            public const string CONTENST = "Contents";
            public const string DESCRIPTION = "Description";
            public const string PAGEVIEWS = "PageViews";
            public const string CREATEBY = "CreatedBy";
            public const string CREATEON = "CreatedOn";
            public const string STATUS = "Status";
            public const string AVATARSMAIL = "AvatarSmail";
            public const string AVATARBIG = "AvatarBig";
            public const string CHECKTYPE = "CheckType";
            public const string M0DIFIEDBY = "ModifiedBy";
            public const string PRICEVAT = "Price_VAT";
            public const string PRIORITY = "Priority";
            public const string KEYWORD = "Keyword";
            public const string MODIFIEDON = "ModifiedOn";
            public const string DEALXU = "DealXu";
            public const string ENDDATE = "EndDate";
            public const string DESCRIPTION_NOTE = "Description_Note";
            public const string DESCRIPTION_HOT = "Description_Hot";
            public const string PRODUCTIDNAME_ENG = "ProductName_Eng";
        }
         #endregion

        #region CITY
        public struct CITY
        {
            public const string CITYID = "CityId";
            public const string CITYNAME = "CityName";
            public const string ISACTIVE = "IsActive";
            public const string CREATEDBY = "CreatedBy";
            public const string PRIORITY = "Priority";
            public const string CREATEDON = "CreatedOn";
        }
        #endregion
        
        #region FAQ_QUESTIONS
        public struct FAQ_QUESTIONS
        {
            public const string FAQ_ID = "FAQ_ID";
            public const string ZONEID = "ZoneId";
            public const string QUESTION = "Question";
            public const string ANSWER = "Answer";
            public const string STATUS = "Status";
            public const string PRIORITY = "Priority";
            public const string CREATEDBY = "CreatedBy";
            public const string CREATEDON = "CreatedOn";
        }
        #endregion

        public struct LOG_CHUYENGOLD
        {
            public const string LOGID = "LogId";
            public const string CREATEDATE = "CreateDate";
            public const string IP = "IP";
            public const string EMAILTRANSFER = "EmailTransfer";
            public const string EMAILGET = "EmailGet";
            public const string GOLD = "Gold";
            public const string DESCRIPTION = "Description";
            public const string CODEMEMBER_T0 = "CodeMember_To";
            public const string CODEMEMBER_FROM = "CodeMember_From";
           
        }
        public struct LOG_MUAHANG
        {
            public const string LOGID = "LogId";
            public const string CREATEDATE = "CreateDate";
            public const string IP = "IP";
            public const string EMAIL = "email";
        }
        public struct MEMBER
        {
            public const string IDMEMBER = "IdMember";
            public const string FULLNAME = "FullName";
            public const string ADDRESS = "Address";
            public const string EMAIL = "Email";
            public const string PASS = "Pass";
            public const string PHONENUMBER = "PhoneNumber";
            public const string STATUS = "Status";
            public const string CODEMEMBER = "CodeMember";
            public const string CODEMEMBERPARENT = "CodeMemberParent";
            public const string CODEPOSITION = "CodePosition";
            public const string CREATEDON = "CreatedOn";
            public const string LEVE = "Leve";
            public const string CHECKTYPE = "Checktype";
            public const string LEFTRIGHT = "LeftRight";
            public const string PRICEMOUNT = "PriceMount";
            public const string DATEBIRTH = "DateBirth";
            public const string NUMBERACOUNT = "NumberAcount";
            public const string NAMEBANK = "NameBank";
            public const string GOLDBONUS = "GoldBonus";           
            public const string ISACTIVE = "IsActive";
            public const string USERNAME = "UserName";
            public const string CMTND = "CMTND";
            public const string PROMOTIONAL = "Promotional";
        }

        public struct PRODUCTCART
        {
            public const string CARTID = "CartId";
            public const string PRODUCTID = "ProductId";
            public const string QUANTITY = "Quantity";
            public const string TOTALPRICE = "TotalPrice";
            public const string CREATEDDATE = "CreatedDate";
            public const string MEMBERID = "MemberId";
        }
        public struct PRODUCTORDER
        {
            public const string ORDERID = "OrderId";
            public const string CODEMEMBER = "CodeMember";
            public const string ORDERDATE = "OrderDate";
            public const string CREATEDDATE = "CreatedDate";
            public const string TOTALPRICE = "TotalPrice";
            public const string NOTES = "Notes";
            public const string STATUS = "Status";
            public const string TOTALDEALXU = "TotalDealxu";
        }
         public struct ProductOrderDetails
          {

             public const string ORDERIDRE= "OrderIdDe";
             public const string PRODUCTID = "ProductId";
             public const string PRODUCTNAME = "ProductName";
             public const string ORDERID = "OrderId";
             public const string QUANTITY = "Quantity";
             public const string PRICE = "Price";
             public const string CREATEDDATE = "CreatedDate";
             public const string DEALXU = "Dealxu";
          }
        

        #region Member
        public const string IDMEMBER = "IdMember";
        public const string FULLNAME = "FullName";
        public const string ADDRESS = "Address";
        public const string BIRTHDAY = "Brithday";
        public const string EMAIL = "Email";
        public const string PASS = "Pass";
        public const string PHONENUMBER = "PhoneNumber";
        public const string STATUS = "Status";
        public const string CODEMEMBER = "CodeMember";
        public const string CODEMEMBERPARENT = "CodeMemberParent";
        public const string CODEPOSITION = "CodePosition";
        public const string CREATEON = "CreatedOn";
        public const string LEVE = "Leve";
        public const string CHECKTYPE = "Checktype";
        public const string LEFTRIGHT = "LeftRight";
        public const string PRICEMOUNT = "PriceMount";
    #endregion

        #region UPGRADEACCOUNT
        public struct UPGRADEACCOUNT
        {
            public const string ID = "Id";
            public const string IDMEMBER = "IdMember";
            public const string CREATEDON = "CreatedOn";
            public const string PRICE = "Price";
            public const string STATUS = "Status";
        }
         #endregion

        #region MEMBER_NOTETREE
        public struct MEMBER_NOTETREE
        {
            public const string ID = "Id";
            public const string CODEMEMBER = "CodeMember";
            public const string CREATEDON = "CreatedOn";
            public const string IDMEMBER = "IdMember";
            public const string FULLNAME = "FullName";
            public const string STATUS = "Status";
            public const string IDMEMBER_ACTIVE = "IdMember_Active";
            public const string CODEMEMBERPARENT = "CodeMemberParent";
            public const string POSITION = "Position";
            public const string FULLNAME_ACTIVE = "fullName_Active";             
            
        }
        #endregion

        #region NewMails
        public struct NEWEMAIL
        {
            public const string IDEMAILS = "IDEmails";
            public const string IDMEMBER = "IdMember";
            public const string TITLE = "Title";
            public const string CONTENTEMAIL = "ContentEmail";
            public const string STATUS = "Status";
            public const string EMAILGET = "EmailGet";
            public const string EMAILTRANSFER = "EmailTransfer";
            public const string CREATEDATE = "CreatedDate";


            public static string CREATEDDATE { get; set; }
        }
        #endregion

        #region COMMENTPRODUCTS
        public struct COMMENTPRODUCTS
        {
            public const string ID = "Id";
            public const string PRODUCTID = "ProductId";
            public const string TITLE = "Title";
            public const string CONTENTS = "Contents";
            public const string CREATEDATE = "CreateDate";
            public const string STATUS = "Status";
            public const string CODEMEMBER = "CodeMember";
        }
        #endregion

        #region PAYMENT
        public struct PAYMENT
        {
            public const string ID = "Id";
            public const string ORDER_ID = "order_id";
            public const string TRANSACTION_ID = "transaction_id";
            public const string CREATED_ON = "created_on";
            public const string PAYMENT_TYPE = "payment_type";
            public const string TRANSACTION_STATUS = "transaction_status";
            public const string TOTAL_AMOUNT = "total_amount";
            public const string NET_AMOUNT = "net_amount";
            public const string FEE_AMOUNT = "fee_amount";
            public const string MERCHANT_ID = "merchant_id";
            public const string CUSTOMER_NAME = "customer_name";
            public const string CUSTOMER_EMAIL = "customer_email";
            public const string CUSTOMER_PHONE = "customer_phone";
            public const string CUSTOMER_ADDRESS = "customer_address";
            public const string CHECKSUM = "checksum";
            public const string ISACTIVE = "isActive";
            public const string CODEMEMBER = "CodeMember";
            
        }
        #endregion

    }
}